﻿-- 删除班组[下属班组也会一并删除]
create procedure [dbo].[Groupinfo_Delete]
@bzid varchar(20)
as
delete from Banz_Info where bzid like @bzid+'%'
-- 删除班组下的所有人员
delete from Bzry_Info where bzid like @bzid+'%'